﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$LocalizationDBConnection$" formatter="bizobj of UiView(fields)">
	<Sql>
		SELECT
		UiViews.name,
		UiControlFields.textId AS fieldsid,
		UiViews.name as fieldsviewName,
		UiControlFields.fieldName as fieldsfieldName,
		UiControlFields.textId as fieldstextId
		FROM
		UiViews
		LEFT OUTER JOIN
		UiControlFields ON UiControlFields.viewName = UiViews.name
		WHERE
		UiViews.name = @name
	</Sql>
	<Param name="name" type="UnicodeVarChar" />
</AdoNetDataAccess>